That format requires you to use either: CASE ebv.db_no WHEN 22978 THEN 'WECS 9500' WHEN 23218 THEN 'WECS 9500' WHEN 23219 THEN 'WECS 9500' ELSE 'WECS 9520' ... ... <看更多>

5 Answers · A CASE expression evaluates to the first true condition. · If there is no true condition, it evaluates to the ELSE part. · If there is no true ... ... <看更多>